/*
 Navicat Premium Data Transfer

 Source Server         : sqlite3
 Source Server Type    : SQLite
 Source Server Version : 3035005 (3.35.5)
 Source Schema         : main

 Target Server Type    : SQLite
 Target Server Version : 3035005 (3.35.5)
 File Encoding         : 65001

 Date: 26/05/2024 21:23:15
*/

PRAGMA foreign_keys = false;

-- ----------------------------
-- Table structure for contact
-- ----------------------------
DROP TABLE IF EXISTS "contact";
CREATE TABLE "contact" (
  "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  "user_id" INTEGER,
  "contact_id" INTEGER
);

-- ----------------------------
-- Records of contact
-- ----------------------------
BEGIN;
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (1, 1, 2);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (2, 1, 3);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (3, 1, 4);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (4, 1, 5);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (5, 1, 6);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (6, 1, 7);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (7, 1, 8);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (8, 1, 9);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (9, 1, 10);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (10, 1, 11);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (11, 1, 12);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (12, 1, 13);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (13, 1, 14);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (14, 1, 15);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (15, 1, 16);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (16, 1, 17);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (17, 1, 18);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (18, 1, 19);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (19, 1, 20);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (20, 1, 21);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (21, 1, 22);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (22, 2, 1);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (23, 2, 3);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (24, 2, 4);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (25, 2, 5);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (26, 2, 6);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (27, 2, 7);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (28, 2, 8);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (29, 2, 9);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (30, 2, 10);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (31, 2, 11);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (32, 2, 12);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (33, 2, 13);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (34, 2, 14);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (35, 2, 15);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (36, 2, 16);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (37, 2, 17);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (38, 2, 18);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (39, 2, 19);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (40, 2, 20);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (41, 2, 21);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (42, 2, 22);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (43, 3, 4);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (44, 3, 5);
INSERT INTO "contact" ("id", "user_id", "contact_id") VALUES (45, 3, 4);
COMMIT;

-- ----------------------------
-- Table structure for recent_chat
-- ----------------------------
DROP TABLE IF EXISTS "recent_chat";
CREATE TABLE "recent_chat" (
  "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  "user_id" INTEGER,
  "icon" TEXT,
  "username" TEXT,
  "last_message" TEXT,
  "last_message_time" text
);

-- ----------------------------
-- Records of recent_chat
-- ----------------------------
BEGIN;
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (1, 1, '用户头像.png', '李白', '今天天气真好，适合写诗。', '2024-05-25 08:30:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (2, 1, '用户头像.png', '杜甫', '刚刚读了你的新诗，很有感触。', '2024-05-25 08:35:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (3, 1, '用户头像.png', '王维', '山居秋暝，很有意境。', '2024-05-25 08:40:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (4, 1, '用户头像.png', '白居易', '赋得古原草送别，真是佳作。', '2024-05-25 08:45:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (5, 1, '用户头像.png', '苏轼', '东坡肉的做法可以分享一下吗？', '2024-05-25 08:50:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (6, 1, '用户头像.png', '辛弃疾', '醉里挑灯看剑，梦回吹角连营。', '2024-05-25 08:55:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (7, 1, '用户头像.png', '李清照', '如梦令，常记溪亭日暮。', '2024-05-25 09:00:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (8, 1, '用户头像.png', '王安石', '变法图强，是为国家着想。', '2024-05-25 09:05:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (9, 1, '用户头像.png', '陆游', '书愤，表达了你的情感。', '2024-05-25 09:10:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (10, 1, '用户头像.png', '陶渊明', '桃花源记，令人向往。', '2024-05-25 09:15:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (11, 1, '用户头像.png', '曹雪芹', '红楼梦中的人物描写得非常细腻。', '2024-05-25 09:20:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (12, 1, '用户头像.png', '罗贯中', '三国演义，历史与小说的完美结合。', '2024-05-25 09:25:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (13, 1, '用户头像.png', '施耐庵', '水浒传，展现了英雄好汉的豪情。', '2024-05-25 09:30:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (14, 1, '用户头像.png', '吴承恩', '西游记，奇幻的旅程。', '2024-05-25 09:35:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (15, 1, '用户头像.png', '鲁迅', '阿Q正传，讽刺了社会的某些现象。', '2024-05-25 09:40:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (16, 1, '用户头像.png', '郭沫若', '女神，展现了你对诗歌的热爱。', '2024-05-25 09:45:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (17, 1, '用户头像.png', '巴金', '家，春，秋，三部曲，深刻描绘了时代变迁。', '2024-05-25 09:50:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (18, 1, '用户头像.png', '老舍', '骆驼祥子，反映了社会底层的生活。', '2024-05-25 09:55:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (19, 1, '用户头像.png', '茅盾', '子夜，揭示了社会矛盾。', '2024-05-25 10:00:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (20, 1, '用户头像.png', '冰心', '繁星·春水，你的诗总是那么清新。', '2024-05-25 10:05:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (21, 2, '用户头像.png', '李白', '今天天气真好，适合写诗。', '2024-05-25 08:30:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (22, 2, '用户头像.png', '杜甫', '刚刚读了你的新诗，很有感触。', '2024-05-25 08:35:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (23, 2, '用户头像.png', '王维', '山居秋暝，很有意境。', '2024-05-25 08:40:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (24, 2, '用户头像.png', '白居易', '赋得古原草送别，真是佳作。', '2024-05-25 08:45:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (25, 2, '用户头像.png', '苏轼', '东坡肉的做法可以分享一下吗？', '2024-05-25 08:50:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (26, 2, '用户头像.png', '辛弃疾', '醉里挑灯看剑，梦回吹角连营。', '2024-05-25 08:55:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (27, 2, '用户头像.png', '李清照', '如梦令，常记溪亭日暮。', '2024-05-25 09:00:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (28, 2, '用户头像.png', '王安石', '变法图强，是为国家着想。', '2024-05-25 09:05:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (29, 2, '用户头像.png', '陆游', '书愤，表达了你的情感。', '2024-05-25 09:10:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (30, 2, '用户头像.png', '陶渊明', '桃花源记，令人向往。', '2024-05-25 09:15:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (31, 2, '用户头像.png', '曹雪芹', '红楼梦中的人物描写得非常细腻。', '2024-05-25 09:20:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (32, 2, '用户头像.png', '罗贯中', '三国演义，历史与小说的完美结合。', '2024-05-25 09:25:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (33, 2, '用户头像.png', '施耐庵', '水浒传，展现了英雄好汉的豪情。', '2024-05-25 09:30:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (34, 2, '用户头像.png', '吴承恩', '西游记，奇幻的旅程。', '2024-05-25 09:35:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (35, 2, '用户头像.png', '鲁迅', '阿Q正传，讽刺了社会的某些现象。', '2024-05-25 09:40:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (36, 2, '用户头像.png', '郭沫若', '女神，展现了你对诗歌的热爱。', '2024-05-25 09:45:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (37, 2, '用户头像.png', '巴金', '家，春，秋，三部曲，深刻描绘了时代变迁。', '2024-05-25 09:50:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (38, 2, '用户头像.png', '老舍', '骆驼祥子，反映了社会底层的生活。', '2024-05-25 09:55:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (39, 2, '用户头像.png', '茅盾', '子夜，揭示了社会矛盾。', '2024-05-25 10:00:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (40, 2, '用户头像.png', '冰心', '繁星·春水，你的诗总是那么清新。', '2024-05-25 10:05:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (41, 3, '用户头像.png', '王安石', '变法图强，是为国家着想。', '2024-05-25 09:05:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (42, 3, '用户头像.png', '陆游', '书愤，表达了你的情感。', '2024-05-25 09:10:00');
INSERT INTO "recent_chat" ("id", "user_id", "icon", "username", "last_message", "last_message_time") VALUES (43, 3, '用户头像.png', '陶渊明', '桃花源记，令人向往。', '2024-05-25 09:15:00');
COMMIT;

-- ----------------------------
-- Table structure for sqlite_sequence
-- ----------------------------
DROP TABLE IF EXISTS "sqlite_sequence";
CREATE TABLE sqlite_sequence(name,seq);

-- ----------------------------
-- Records of sqlite_sequence
-- ----------------------------
BEGIN;
INSERT INTO "sqlite_sequence" ("name", "seq") VALUES ('contact', 45);
INSERT INTO "sqlite_sequence" ("name", "seq") VALUES ('recent_chat', 43);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS "sys_user";
CREATE TABLE "sys_user" (
  "id" INTEGER NOT NULL,
  "username" TEXT,
  "password" TEXT,
  "icon" TEXT,
  "email" TEXT,
  "nick_name" TEXT,
  "note" TEXT,
  "status" integer NOT NULL DEFAULT 1,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (1, 'admin', '123456', '超级管理员.png', 'admin@chat.com', '超级管理员', '1号位', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (2, 'test', 'test', '测试员.png', 'test@chat.com', '测试员', '2号位', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (3, 'lirenbaidi', '123456', '用户头像.png', 'lbaidi@example.com', '李白', '唐代著名诗人', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (4, 'gudaifu', '123456', '用户头像.png', 'gudaifu@example.com', '杜甫', '唐代著名诗人', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (5, 'wangwei', '123456', '用户头像.png', 'wangwei@example.com', '王维', '唐代著名诗人和画家', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (6, 'baijuyi', '123456', '用户头像.png', 'baijuyi@example.com', '白居易', '唐代著名诗人', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (7, 'sushi', '123456', '用户头像.png', 'sushi@example.com', '苏轼', '宋代著名文学家', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (8, 'xinqiji', '123456', '用户头像.png', 'xinqiji@example.com', '辛弃疾', '宋代著名词人', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (9, 'liqingzhao', '123456', '用户头像.png', 'liqingzhao@example.com', '李清照', '宋代著名女词人', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (10, 'wanganshi', '123456', '用户头像.png', 'wanganshi@example.com', '王安石', '宋代政治家、文学家', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (11, 'luyou', '123456', '用户头像.png', 'luyou@example.com', '陆游', '宋代著名诗人', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (12, 'taoyuanming', '123456', '用户头像.png', 'taoyuanming@example.com', '陶渊明', '东晋时期著名诗人', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (13, 'caoxueqin', '123456', '用户头像.png', 'caoxueqin@example.com', '曹雪芹', '清代著名小说家', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (14, 'luoguanzhong', '123456', '用户头像.png', 'luoguanzhong@example.com', '罗贯中', '明代小说家', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (15, 'shinaian', '123456', '用户头像.png', 'shinaian@example.com', '施耐庵', '明代小说家', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (16, 'wuchengnian', '123456', '用户头像.png', 'wuchengnian@example.com', '吴承恩', '明代小说家', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (17, 'luxun', '123456', '用户头像.png', 'luxun@example.com', '鲁迅', '现代著名作家', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (18, 'guomouruo', '123456', '用户头像.png', 'guomouruo@example.com', '郭沫若', '现代著名诗人、剧作家', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (19, 'bajin', '123456', '用户头像.png', 'bajin@example.com', '巴金', '现代著名作家', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (20, 'laoshe', '123456', '用户头像.png', 'laoshe@example.com', '老舍', '现代著名作家', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (21, 'maodun', '123456', '用户头像.png', 'maodun@example.com', '茅盾', '现代著名作家', 1);
INSERT INTO "sys_user" ("id", "username", "password", "icon", "email", "nick_name", "note", "status") VALUES (22, 'bingxin', '123456', '用户头像.png', 'bingxin@example.com', '冰心', '现代著名女作家', 1);
COMMIT;

-- ----------------------------
-- Auto increment value for contact
-- ----------------------------
UPDATE "main"."sqlite_sequence" SET seq = 45 WHERE name = 'contact';

-- ----------------------------
-- Auto increment value for recent_chat
-- ----------------------------
UPDATE "main"."sqlite_sequence" SET seq = 43 WHERE name = 'recent_chat';

PRAGMA foreign_keys = true;
